Employee

Entity Definition Logical Name : Employee Physical Name : PA_EM An individual that works for a retail store, accepts direction from the retail store management and satisfies the statutory criteria requiring that payroll taxes and benefit contributions be paid by the retailer.

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
EmployeeID (PK)	A unique, non-significant number used to identify a store employee.	ID_EM	Identity	integer
WorkerID (FK)	A unique system-assigned identifier for the Person who is a particular Worker.	ID_WRKR	Identity	integer	Worker(PA_WRKR)
StatusCode	The status code regarding the EMPLOYEE, i.e. active or inactive.	SC_EM	Code2Status	char(2)

Parent Entity	Verb Phrase	Child Entity
Worker	is a	Employee

Logical View
Logical 02305 - Retail Transaction - Header View
Logical 02310 - Retail Transaction - Item Sale View
Logical 06310 - Party - Role View
Logical 06330 - Party - Identification View
Logical 06700 - Event Scheduler View
Logical 11100 - Worker - Macro View
Logical 11160 - Worker - Reporting View